﻿using System;
using System.Collections.Generic;
using System.Text;

namespace Kalficom.Query
{
    class qry_User
    {
        internal string get = "SELECT * FROM k_user";
        internal string added = "INSERT INTO k_user(user_login, user_pwd, user_is_admin, user_is_tablet, user_can_create_contract, user_can_update_calypso, user_first_name, user_last_name, user_email, user_phone, user_create, user_date) VALUES({0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}, {11})";
        internal string updated = "UPDATE k_user SET user_login={0}, user_pwd={1}, user_is_admin={2}, user_is_tablet={3}, user_can_create_contract={4}, user_can_update_calypso={5} WHERE user_id={6}";
        internal string deleted = "DELETE FROM k_user WHERE user_id={0}";
        internal string scalarID = "SELECT user_id FROM k_user WHERE user_login={0}";
        internal string get_where = "SELECT * FROM k_user WHERE user_id={0}";
        internal string scalarIsAdmin = "SELECT user_is_admin FROM k_user WHERE user_id={0}";
        internal string scalarIsTablet = "SELECT user_is_tablet FROM k_user WHERE user_id={0}";
        internal string scalarIsContart = "SELECT user_can_create_contract FROM k_user WHERE user_id={0}";
        internal string scalarIsCalypso = "SELECT user_can_update_calypso FROM k_user WHERE user_id={0}";
    }
}
